Operators and Functions¶

Logical Operators
Comparison Operators
Arithmetic Operators
- Arithmetic Operations and Type Casting of Numeric Data Types
- Arithmetic Operations and Type Casting of DATE/TIME Data Types
Set Arithmetic Operators
- SET, MULTISET, LIST
Statement Set Operators
- UNION, DIFFERENCE, INTERSECTION
Containment Operators
- SETEQ
- SETNEQ
- SUPERSET
- SUPERSETEQ
- SUBSET
- SUBSETEQ
BIT Functions and Operators
- Bitwise Operator
- BIT_AND
- BIT_OR
- BIT_XOR
- BIT_COUNT
String Functions and Operators
- Concatenation Operator
- ASCII
- BIN
- BIT_LENGTH
- CHAR_LENGTH, CHARACTER_LENGTH, LENGTHB, LENGTH
- CHR
- CONCAT
- CONCAT_WS
- ELT
- FIELD
- FIND_IN_SET
- FROM_BASE64
- INSERT
- INSTR
- LCASE, LOWER
- LEFT
- LOCATE
- LPAD
- LTRIM
- MID
- OCTET_LENGTH
- POSITION
- REPEAT
- REPLACE
- REVERSE
- RIGHT
- RPAD
- RTRIM
- SPACE
- STRCMP
- SUBSTR
- SUBSTRING
- SUBSTRING_INDEX
- TO_BASE64
- TRANSLATE
- TRIM
- UCASE, UPPER
Numeric/Mathematical Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATAN2
- CEIL
- CONV
- COS
- COT
- CRC32
- DEGREES
- DRANDOM, DRAND
- EXP
- FLOOR
- HEX
- LN
- LOG2
- LOG10
- MOD
- PI
- POW, POWER
- RADIANS
- RANDOM, RAND
- ROUND
- SIGN
- SIN
- SQRT
- TAN
- TRUNC, TRUNCATE
- WIDTH_BUCKET
Date/Time Functions and Operators
- ADDDATE, DATE_ADD
- ADDTIME
- ADD_MONTHS
- CURDATE, CURRENT_DATE
- CURRENT_DATETIME, NOW
- CURTIME, CURRENT_TIME
- CURRENT_TIMESTAMP, LOCALTIME, LOCALTIMESTAMP
- DATE
- DATEDIFF
- DATE_SUB, SUBDATE
- DAY, DAYOFMONTH
- DAYOFWEEK
- DAYOFYEAR
- EXTRACT
- FROM_DAYS
- FROM_TZ
- FROM_UNIXTIME
- HOUR
- LAST_DAY
- MAKEDATE
- MAKETIME
- MINUTE
- MONTH
- MONTHS_BETWEEN
- NEW_TIME
- QUARTER
- ROUND
- SEC_TO_TIME
- SECOND
- SYS_DATE, SYSDATE
- SYS_DATETIME, SYSDATETIME
- SYS_TIME, SYSTIME
- SYS_TIMESTAMP, SYSTIMESTAMP
- TIME
- TIME_TO_SEC
- TIMEDIFF
- TIMESTAMP
- TO_DAYS
- TRUNC
- TZ_OFFSET
- UNIX_TIMESTAMP
- UTC_DATE
- UTC_TIME
- WEEK
- WEEKDAY
- YEAR
LOB Functions
- BIT_TO_BLOB
- BLOB_FROM_FILE
- BLOB_LENGTH
- BLOB_TO_BIT
- CHAR_TO_BLOB
- CHAR_TO_CLOB
- CLOB_FROM_FILE
- CLOB_LENGTH
- CLOB_TO_CHAR
Data Type Casting Functions and Operators
- CAST
- DATE_FORMAT
- FORMAT
- STR_TO_DATE
- TIME_FORMAT
- TO_CHAR(date_time)
- TO_CHAR(number)
- TO_DATE
- TO_DATETIME
- TO_DATETIME_TZ
- TO_NUMBER
- TO_TIME
- TO_TIMESTAMP
- TO_TIMESTAMP_TZ
Aggregate/Analytic Functions
- Overview
- Aggregate vs. Analytic
- Analytic functions which "ORDER BY" clause must be specified in OVER function
- AVG
- COUNT
- CUME_DIST
- DENSE_RANK
- FIRST_VALUE
- GROUP_CONCAT
- LAG
- LAST_VALUE
- LEAD
- MAX
- MEDIAN
- MIN
- NTH_VALUE
- NTILE
- PERCENT_RANK
- PERCENTILE_CONT
- PERCENTILE_DISC
- RANK
- ROW_NUMBER
- STDDEV, STDDEV_POP
- STDDEV_SAMP
- SUM
- VARIANCE, VAR_POP
- VAR_SAMP
Click Counter Functions
- INCR, DECR
ROWNUM Functions
- ROWNUM, INST_NUM
- ORDERBY_NUM
- GROUPBY_NUM
Information Functions
- CHARSET
- COERCIBILITY
- COLLATION
- CURRENT_USER, USER
- DATABASE, SCHEMA
- DBTIMEZONE
- DEFAULT
- INDEX_CARDINALITY
- INET_ATON
- INET_NTOA
- LAST_INSERT_ID
- LIST_DBS
- ROW_COUNT
- SESSIONTIMEZONE
- USER, SYSTEM_USER
- VERSION
Encryption Function
- MD5
- SHA1
- SHA2
Comparison Expression
- Simple Comparison Expression
- ANY/SOME/ALL quantifiers
- BETWEEN
- EXISTS
- IN
- IS NULL
- LIKE
- REGEXP, RLIKE
- CASE
Comparison Functions
- COALESCE
- DECODE
- GREATEST
- IF
- IFNULL, NVL
- ISNULL
- LEAST
- NULLIF
- NVL2
Other functions
- SLEEP
- SYS_GUID